﻿IF object_id(N'dbo.TabAccountInfo', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabAccountInfo] (
        [UserID]       numeric(18,0) NOT NULL,
        [SenderName]   nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,
        [CnName]       nvarchar(20)  COLLATE Chinese_PRC_CI_AS NULL,
        [EnName]       nvarchar(20)  COLLATE Chinese_PRC_CI_AS NULL,
        [EmailAddress] nvarchar(80)  COLLATE Chinese_PRC_CI_AS NULL,
        [Descn]        nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,

        CONSTRAINT [PK_TabAccountInfo] PRIMARY KEY CLUSTERED ([UserID] asc),
        CONSTRAINT [FK_TabAccountInfo_TabAccountIndex] FOREIGN KEY ([UserID]) REFERENCES [dbo].[TabAccountIndex] ([UserID]) ON DELETE CASCADE ON UPDATE CASCADE
    );
END
GO
